﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;

using PowerCreator.LMS.DL.Project.Entity;
using PowerCreator.LMS.Web.DL.Project;
using PowerCreator.LMS.Common.Script;
public partial class sysadmin_DL_Project_ManageClassLevel : PowerCreator.LMS.Web.Base.WebBasePage
{
    protected string ClassName = string.Empty;
    protected string ClassUserNum = string.Empty;
    PowerCreator.LMS.ViewQuery.ViewQuery obj = new PowerCreator.LMS.ViewQuery.ViewQuery();
    VOTOClass voClass = new VOTOClass();
    TOClass objClass = new TOClass();
    TOUserOfClass objClassUser = new TOUserOfClass();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            InitPage();
            int CID = 0;
            if (Request.QueryString["CID"] != null)
            {
                CID = int.Parse(Request.QueryString["CID"].ToString());
                ViewState["CID"] = CID.ToString();
                voClass = objClass.Load(CID);
                ClassName = voClass.Name;
                string search = GetSearch(CID);
                BinderPG(search);
            }
        }
    } 

    protected override void InitPage()
    {
        //lbl_InfoTitle_ManagerNew.Text = GetLanageValueByKey("lab_ManagerNew_InfoTitle", PowerCreator.LMS.Language.LanagetItemType.Page);
        //lbl_ManagerNew.Text = "新闻列表";
        btnSearch.Text = GetLanageValueByKey("btn_Search", PowerCreator.LMS.Language.LanagetItemType.Page);

        
        base.InitPage();

        //btnAddNew.Visible = false;
        //if (IsLicensed(PowerCreator.LMS.Action.Core.ActionInfo.AddJob))
        //    btnAddNew.Visible = true;

    }
    private string GetSearch(int cid)
    {
        string search = "SELECT TO_UserOfClass.UOC_ID, TO_UserOfClass.UserID,  TO_Learner.UserName, TO_Learner.TeacherId, TO_Learner.Name,  TO_Learner.UserGroup, TO_Learner.UserPIC, TO_Learner.Mobile,  TO_Learner.Email, TO_Learner.ZhiCheng, TO_Learner.ZhiWu,  TO_Learner.Education,TO_UserOfClass.IsCourseFDY,TO_UserOfClass.TrainScore,TO_UserOfClass.TrainLevel FROM TO_Learner ,TO_UserOfClass where TO_Learner.Learner_Id = TO_UserOfClass.UserID  and TO_UserOfClass.ClassID=" + cid;
        if (!string.IsNullOrEmpty(txt_KeyWord.Text))
            search += string.Format(" and ( TO_Learner.Name like '%{0}%' or  TO_Learner.UserName like '%{0}%')", txt_KeyWord.Text.Trim());
        //search += " order by DLSchool.ID Desc";
        return search;
    }


    private void BinderPG(string search)
    {
        DataTable dt = obj.Query(search);
        ClassUserNum = dt.Rows.Count.ToString();

        rptNew.DataSource = dt;
        rptNew.DataBind();
    }


    protected void btnSearch_Click(object sender, EventArgs e)
    {
        string search = GetSearch(int.Parse(ViewState["CID"].ToString()));
        BinderPG(search);
    }
    protected void btnAddNew_Click(object sender, EventArgs e)
    {
        string url = "AddClassUser.aspx?CID=" + ViewState["CID"].ToString();
        Script.RedirectURL(url);
    }
  
    protected void rptNew_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        Label lbl_msg = (Label)e.Item.FindControl("lbl_msg");

        if (e.CommandName.ToLower() == "ledit")
        {
            string url = "SetClassLevel.aspx?CUID=" + e.CommandArgument.ToString() + "&CID=" + ViewState["CID"].ToString();
            Script.RedirectURL(url);
           
        }
      
       
    }
   
 
}